/*
 Navicat Premium Data Transfer

 Source Server         : localhost3308
 Source Server Type    : MySQL
 Source Server Version : 50720
 Source Host           : localhost:3308
 Source Schema         : ml_order

 Target Server Type    : MySQL
 Target Server Version : 50720
 File Encoding         : 65001

 Date: 04/12/2020 16:16:01
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for ml_order
-- ----------------------------
DROP TABLE IF EXISTS `ml_order`;
CREATE TABLE `ml_order` (
  `order_id` bigint(20) NOT NULL COMMENT '订单ID主键',
  `order_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'status:0:失败,1:成功',
  `order_amount` decimal(20,0) NOT NULL COMMENT '订单支付金额',
  `receive_user` varchar(255) DEFAULT NULL COMMENT '收货人',
  `reveive_mobile` varchar(255) DEFAULT NULL COMMENT '收货人电话',
  `create_user` bigint(255) DEFAULT NULL COMMENT '创建人',
  `creata_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_user` bigint(20) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`order_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='订单表';

-- ----------------------------
-- Records of ml_order
-- ----------------------------
BEGIN;
INSERT INTO `ml_order` VALUES (1001, 0, 200, 'fanghuaiming', '17612155892', 1, '2020-12-04 16:12:35', 0, '2020-12-04 16:12:35');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
